package com.yssoft.entity.supplier;

import java.util.List;
import java.util.Map;
/**
 * 
    * @ClassName: ProcurementInfo
    * @Description: 采购信息
    * @author lenovo
    * @date 2018年6月14日
    *
 */
public class ProcurementInfo {
	private Integer recipientId;
	private Integer procurementInfoId;
	private Integer worksheetId;
	private Integer materialId;
	private String supplierId;
	private String supplierName;
	private String contact;
	private String phone;
	private String supplyTime;
	private Double quantity;
	private String materialName;
	private String pprocurementInfoCode;
	List<Map<String,Object>> materiaDetaillList;
	public Integer getProcurementInfoId() {
		return procurementInfoId;
	}
	public void setProcurementInfoId(Integer procurementInfoId) {
		this.procurementInfoId = procurementInfoId;
	}
	public Integer getWorksheetId() {
		return worksheetId;
	}
	public void setWorksheetId(Integer worksheetId) {
		this.worksheetId = worksheetId;
	}
	public Integer getMaterialId() {
		return materialId;
	}
	public void setMaterialId(Integer materialId) {
		this.materialId = materialId;
	}
	public String getSupplierId() {
		return supplierId;
	}
	public void setSupplierId(String supplierId) {
		this.supplierId = supplierId;
	}
	public String getSupplierName() {
		return supplierName;
	}
	public void setSupplierName(String supplierName) {
		this.supplierName = supplierName;
	}
	public String getContact() {
		return contact;
	}
	public void setContact(String contact) {
		this.contact = contact;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getSupplyTime() {
		return supplyTime;
	}
	public void setSupplyTime(String supplyTime) {
		this.supplyTime = supplyTime;
	}
	public Double getQuantity() {
		return quantity;
	}
	public void setQuantity(Double quantity) {
		this.quantity = quantity;
	}
	public String getMaterialName() {
		return materialName;
	}
	public void setMaterialName(String materialName) {
		this.materialName = materialName;
	}
	public String getPprocurementInfoCode() {
		return pprocurementInfoCode;
	}
	public void setPprocurementInfoCode(String pprocurementInfoCode) {
		this.pprocurementInfoCode = pprocurementInfoCode;
	}
	public List<Map<String, Object>> getMateriaDetaillList() {
		return materiaDetaillList;
	}
	public void setMateriaDetaillList(List<Map<String, Object>> materiaDetaillList) {
		this.materiaDetaillList = materiaDetaillList;
	}
	public Integer getRecipientId() {
		return recipientId;
	}
	public void setRecipientId(Integer recipientId) {
		this.recipientId = recipientId;
	}
	 
	
}
	/*SELECT
	   w.id worksheetId,
	   s.name  supplierName,s.contact contact,s.phone phone,
	   dd.supply_time supplyTime,dd.t_m_id  materialId  ,ifnull(dd.quantity,0) quantity
	   
	FROM  t_worksheet w
	left join t_collar_material cm ON w.id = cm.t_workshee_id
	left join t_collar_material_detail cmd on cmd.t_c_material_id=cm.id
	left join t_outstock_apply oa on oa.id=cmd.t_outstock_app_id
	left join t_outstock_apply_detail oad on oad.t_outstock_app_id =oa.id
	left join t_out_in_stock  ois on ois.t_outstock_detail_id
left join t_instock_apply_detail iad on iad.id=ois.t_instock_detail_id
left join t_recipient_detail  rd  on rd.id=iad.t_source_id
left join t_demand_detail dd on dd.id=rd.t_dd_id
left join t_purchase_detail  pd on  pd.t_d_id=dd.id
left join t_purchase_info  pi on pd.id=pd.t_p_id
left join t_supplier s on s.id=pi.t_s_id */